import pandas as pd
dataset = pd.read_csv("C:/Users/ROHIT/Documents/ok.csv")
dataset
| State | District | Year | NumberOfCrimes | CrimeType | CrimeGroup | Region | |
|---|---|---|---|---|---|---|---|
| 0 | Andhra Pradesh | Adilabad | 2001 | 178 | MURDER | HOMICIDE | SOUTH |
| 1 | Andhra Pradesh | Anantapur | 2001 | 277 | MURDER | HOMICIDE | SOUTH |
| 2 | Andhra Pradesh | Chittoor | 2001 | 160 | MURDER | HOMICIDE | SOUTH |
| 3 | Andhra Pradesh | Cuddapah | 2001 | 134 | MURDER | HOMICIDE | SOUTH |
| 4 | Andhra Pradesh | East Godavari | 2001 | 150 | MURDER | HOMICIDE | SOUTH |
| ... | ... | ... | ... | ... | ... | ... | ... |
| 203903 | Jammu and Kashmir | Srinagar | 2014 | 0 | MURDER | HOMICIDE | NORTH |
| 203904 | Jammu and Kashmir | Srinagar | 2014 | 0 | KIDNAPPING & ABDUCTION | KIDNAPPING & ABDUCTION | NORTH |
| 203905 | Jammu and Kashmir | Srinagar | 2014 | 0 | OTHER IPC CRIMES | OTHERS | NORTH |
| 203906 | Jammu and Kashmir | Srinagar | 2014 | 0 | AUTO THEFT | PROPERTY STOLEN | NORTH |
| 203907 | Jammu and Kashmir | Srinagar | 2014 | 0 | CHEATING | SERIOUS FRAUD | NORTH |
203908 rows × 7 columns
import numpy as np
import matplotlib.pyplot as plt
%matplotlib inline
from matplotlib import style
df = dataset.groupby('State',as_index=False)[['NumberOfCrimes']].sum()
state = df['State']
crime = df['NumberOfCrimes']
Ypts = np.arange(len(crime))
import plotly.express as px
fig = px.bar(df, x="NumberOfCrimes", y="State", orientation='h')
fig.show()
import plotly.express as px
df = dataset.groupby('Year',as_index=False)[['NumberOfCrimes']].sum()
px.treemap(data_frame=df,path=['Year'],values='NumberOfCrimes',color='NumberOfCrimes',color_continuous_scale='rdbu')
df = dataset.groupby('Region',as_index=False)[['NumberOfCrimes']].sum()
df
| Region | NumberOfCrimes | |
|---|---|---|
| 0 | ARABIAN SEA | 858 |
| 1 | BAY OF BENGAL | 10217 |
| 2 | CENTRAL | 3540124 |
| 3 | EAST | 4473617 |
| 4 | NORTH | 7203585 |
| 5 | NORTH-EAST | 1001489 |
| 6 | SOUTH | 8264146 |
| 7 | WEST | 4410987 |
x = df['Region'].values
y = df['NumberOfCrimes'].values
z = df.index
import plotly.express as px
fig = px.scatter(df,x="Region", y="NumberOfCrimes",
size="NumberOfCrimes", color="Region",
hover_name=df.index,size_max=60)
fig.show()
df = dataset.groupby('District',as_index=False)[['NumberOfCrimes']].sum()
names = df['District']
values = df['NumberOfCrimes']
fig = px.pie(df,
names = names,
values = values,
title = 'District wise crimes'
)
fig.update_traces(
textposition = 'inside',
textinfo = 'percent+label'
)
fig.update_layout(
title_font_size = 42
)
fig.show()